/*
 Navicat Premium Data Transfer

 Source Server         : localhost_3306
 Source Server Type    : MySQL
 Source Server Version : 80037 (8.0.37)
 Source Host           : localhost:3306
 Source Schema         : family

 Target Server Type    : MySQL
 Target Server Version : 80037 (8.0.37)
 File Encoding         : 65001

 Date: 01/07/2024 15:08:12
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for event
-- ----------------------------
DROP TABLE IF EXISTS `event`;
CREATE TABLE `event`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `genealogy_id` int NULL DEFAULT NULL,
  `date_point` varchar(200) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `title` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `content` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `updatetime` datetime NULL DEFAULT NULL,
  `userID` int NULL DEFAULT NULL,
  `delflag` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 22 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of event
-- ----------------------------
BEGIN;
INSERT INTO `event` (`id`, `genealogy_id`, `date_point`, `title`, `content`, `updatetime`, `userID`, `delflag`) VALUES (6, 1, '1914-7', '革命', '孙中山在东京宣告中华革命党正式成立，蒋介石被派往上海、哈尔滨协助陈其美从事反对袁世凯的革命活动。', '2024-06-26 18:26:43', 1, 0), (7, 1, '1926-1', '任命', '国民党第二届全国代表大会上，当选为中央执行委员、中央常务委员；2月兼任国民革命军总司令', '2024-06-26 18:26:43', 1, 0), (8, 1, '1926-7', '北伐', '北伐战争开始后，蒋介石率总司令部赴前线指挥作战。国民革命军在工人农民支援下打垮了北洋军阀吴佩孚、孙传芳，湘、鄂、赣、闽四省完全光复，并继续向豫、皖、苏、浙进军', '2024-06-26 18:26:43', 1, 0), (9, 37, '1916-10', '出生', '于日本出生，被收养', '2024-06-26 18:26:43', 1, 0), (10, 38, '1927-04', '发文', '四一二反革命政变后，曾发表声明指责蒋介石叛变革命', '2024-06-26 18:26:43', 1, 0), (11, 38, '1935', '结婚', '苏联女工费娜（ 后改名蒋方良） 结婚 ', '2024-06-26 18:26:43', 1, 0), (12, 38, '1972', '担任', '出任台湾“国民政府” “行政院” 院长', '2024-06-26 18:26:43', 1, 0);
COMMIT;

-- ----------------------------
-- Table structure for people
-- ----------------------------
DROP TABLE IF EXISTS `people`;
CREATE TABLE `people`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `parent_id` int NULL DEFAULT NULL,
  `name` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `sex` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `image` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `brithday` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `deadday` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NULL DEFAULT NULL,
  `updatetime` datetime NULL DEFAULT NULL,
  `userID` int NULL DEFAULT NULL,
  `delflag` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE,
  INDEX `USER`(`userID` ASC) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 68 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of people
-- ----------------------------
BEGIN;
INSERT INTO `people` (`id`, `parent_id`, `name`, `sex`, `image`, `brithday`, `deadday`, `updatetime`, `userID`, `delflag`) VALUES (1, 0, '蒋介石', '男', 'http://localhost:8081/upload/2023-7/file-4fbeb70860694608bd821cdbfcae675b.png', '1887-10-31', '1975-04-05', '2024-06-26 18:26:43', 1, 0), (37, 1, '蒋纬国', '男', 'http://localhost:8081/upload/2023-7/file-68603a33b298495ea38a65f4199e2020.png', '1916-10-06', '1997-09-23', '2024-06-26 18:26:43', 1, 0), (38, 1, '蒋经国', '男', 'http://localhost:8081/upload/2023-7/file-b379998f3c9b4bf1bbdb53cc218c93a3.png', '1910-04-27', '1988-01-13', '2024-06-26 18:26:43', 1, 0), (39, 37, '蒋孝刚', '男', 'http://localhost:8081/upload/2023-7/file-322ddeaf024b4bd0a5cf1d3205bdb361.png', '1963-00-00', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (40, 39, '蒋友捷', '男', 'http://localhost:8081/upload/2023-7/file-3456827b5c634d9da50faa0185c945ea.png', '0000-00-00', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (41, 38, '蒋孝文', '男', 'http://localhost:8081/upload/2023-7/file-0fbaa0b01e664ff581adce69d8d46ec1.png', '1935-12-14', '1989-04-14', '2024-06-26 18:26:43', 1, 0), (42, 41, '蒋友梅', '女', 'http://localhost:8081/upload/2023-7/file-025166e9133f4a64a9a34176a6b3e195.png', '1961-00-00', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (43, 38, '蒋孝章', '女', 'http://localhost:8081/upload/2023-7/file-f6afd8d159454be6aeeac66ddf5ba4b6.png', '1938-00-00', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (44, 38, '蒋孝武', '男', 'http://localhost:8081/upload/2023-7/file-198849476eb941f4870de1725621d7a3.png', '1945-04-25', '1991-07-01', '2024-06-26 18:26:43', 1, 0), (45, 44, '蒋友松', '男', 'http://localhost:8081/upload/2023-7/file-c871262900fa475e9c82b53b20a53556.png', '0000-00-00', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (46, 44, '蒋友兰', '女', 'http://localhost:8081/upload/2023-7/file-6c982d3b5d844e709ff459a75a5dc15a.png', '0000-00-00', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (47, 38, '蒋孝勇', '男', 'http://localhost:8081/upload/2023-7/file-00cf8f75fec7496cb93b8e41480af447.png', '1948-10-27', '1996-00-00', '2024-06-26 18:26:43', 1, 0), (48, 47, '蒋友柏', '男', 'http://localhost:8081/upload/2023-7/file-57a20353c4c34b05ac1e75b700b16dff.png', '1976-09-10', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (49, 47, '蒋友常', '男', 'http://localhost:8081/upload/2023-7/file-e58c611b5e44408f98b6b40fcc6049a5.png', '1978-11-09', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (50, 47, '蒋友青', '男', 'http://localhost:8081/upload/2023-7/file-0dc92091712e416f9554636b8096e813.png', '1989-00-00', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (51, 38, '蒋孝严', '男', 'http://localhost:8081/upload/2023-7/file-c5062bdf36a34c438bd23b8b381441f6.png', '1942-00-00', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (52, 51, '蒋万安', '男', 'http://localhost:8081/upload/2023-7/file-ada5ec6944174acb9127ba6888f2fcbb.png', '1978-12-16', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (53, 51, '蒋惠兰', '女', 'http://localhost:8081/upload/2023-7/file-6ac4f97ab50948efa562fcbff6af9565.png', '0000-00-00', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (54, 51, '蒋惠筠', '女', 'http://localhost:8081/upload/2023-7/file-64eacd9b950a4b73ba0f68ecf55fd13d.png', '0000-00-00', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (55, 38, '蒋孝慈', '男', 'http://localhost:8081/upload/2023-7/file-5545628749f943fc90a111cfda2b438e.png', '1942-05-02', '1996-02-24', '2024-06-26 18:26:43', 1, 0), (56, 55, '蒋友菊', '女', 'http://localhost:8081/upload/2023-7/file-5d2955bcc5a3402196f6974824d5ef46.png', '0000-00-00', '0000-00-00', '2024-06-26 18:26:43', 1, 0), (62, 1, '哈力娜', '女', '', '2004-8-3', '无', '2024-06-26 18:26:43', 1, 1), (63, 1, '哈力娜', '女', '', '2004-8-3', '无', '2024-06-26 18:26:43', 1, 1), (64, 1, '哈力娜', '女', '', '2004-8-3', '无', '2024-06-26 18:26:43', 1, 1), (65, 56, '张三', '沃尔玛购物袋', NULL, '2004-8-3', '无', '2024-06-26 18:26:43', 1, 1), (66, 40, '张三', '男', '', '2004-8-3', '无', '2024-06-26 18:26:43', 1, 1), (67, 43, '张三', '女', '', '2004-8-3', '无', '2024-06-26 18:26:43', 1, 1);
COMMIT;

-- ----------------------------
-- Table structure for system_admin
-- ----------------------------
DROP TABLE IF EXISTS `system_admin`;
CREATE TABLE `system_admin`  (
  `id` int NOT NULL AUTO_INCREMENT,
  `username` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `password` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `name` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `telephone` varchar(20) CHARACTER SET utf8mb3 COLLATE utf8mb3_general_ci NULL DEFAULT NULL,
  `delflag` int NULL DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8mb3 COLLATE = utf8mb3_general_ci;

-- ----------------------------
-- Records of system_admin
-- ----------------------------
BEGIN;
INSERT INTO `system_admin` (`id`, `username`, `password`, `name`, `telephone`, `delflag`) VALUES (1, 'admin', '12345', '管理员', '188888888888', 0);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
